-
Re: I'm trying to create a checkbox that will be selected when two criteria are met
Hi Mahshad, @Mahshad Farmanbar Try something like this. =IF(AND([End Date]@row <= TODAY(90); Status@row = "In Progress"); 1; 0) The same version but with the below changes for your and o…10 · -
Re: Using Date within formulas to calculate Harvey Balls with duo criteria
Hi Teresa, Try something like this. =IF(AND(Status@row = "To Do"; [Projected Start Date]@row <= TODAY()); 1) The same version but with the below changes for your and others convenience. …10 · -
Re: Can a workflow be designed to reference a data field in another sheet?
Hi William, Yes, you can. You’d cross-sheet formulas and VLOOKUP or INDEX/MATCH to set it up. INDEX MATCH VLOOKUP Would that work? I hope that helps! Have a fantastic weekend! Best, Andrée Starå Work…5 · -
Two new functions released (COUNTM & HAS)
Hi everyone, I noticed that two new functions has been released. COUNTM and HAS Here are the details. COUNTM Counts the number of elements in a multi-contact or multi-select dropdown column cell or c…6 ·